Overview
Brought to you by YData
Dataset statistics
| Number of variables | 17 |
|---|---|
| Number of observations | 3509 |
| Missing cells | 4114 |
| Missing cells (%) | 6.9% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 466.0 KiB |
| Average record size in memory | 136.0 B |
Variable types
| Text | 2 |
|---|---|
| Categorical | 5 |
| Numeric | 9 |
| DateTime | 1 |
Area (SQM) is highly overall correlated with Floor Max and 2 other fields | High correlation |
District Name is highly overall correlated with Lease Years and 1 other fields | High correlation |
Floor Category is highly overall correlated with Floor Max and 3 other fields | High correlation |
Floor Max is highly overall correlated with Area (SQM) and 3 other fields | High correlation |
Floor Min is highly overall correlated with Area (SQM) and 3 other fields | High correlation |
Lease Years is highly overall correlated with District Name and 1 other fields | High correlation |
Postal District is highly overall correlated with District Name | High correlation |
Property Type is highly overall correlated with Floor Category and 1 other fields | High correlation |
Tenure Type is highly overall correlated with Lease Years | High correlation |
Transacted Price ($) is highly overall correlated with Area (SQM) and 1 other fields | High correlation |
Type of Area is highly overall correlated with Floor Category and 3 other fields | High correlation |
Unit Price ($ PSM) is highly overall correlated with Transacted Price ($) | High correlation |
Project Name has 879 (25.0%) missing values | Missing |
Lease Years has 1453 (41.4%) missing values | Missing |
Floor Min has 891 (25.4%) missing values | Missing |
Floor Max has 891 (25.4%) missing values | Missing |
Area (SQM) is highly skewed (γ1 = 29.90420506) | Skewed |
Reproduction
| Analysis started | 2024-11-22 10:53:22.224620 |
|---|---|
| Analysis finished | 2024-11-22 10:53:25.580478 |
| Duration | 3.36 seconds |
| Software version | ydata-profiling vv4.12.0 |
| Download configuration | config.json |
Variables
Project Name
Text
Missing
| Distinct | 309 |
|---|---|
| Distinct (%) | 11.7% |
| Missing | 879 |
| Missing (%) | 25.0% |
| Memory size | 54.8 KiB |
Length
| Max length | 32 |
|---|---|
| Median length | 26 |
| Mean length | 14.512928 |
| Min length | 3 |
Unique
| Unique | 105 ? |
|---|---|
| Unique (%) | 4.0% |
Sample
| 1st row | SUNSHINE PLAZA |
|---|---|
| 2nd row | PAYA LEBAR SQUARE |
| 3rd row | WOODS SQUARE |
| 4th row | SUNSHINE PLAZA |
| 5th row | INTERNATIONAL PLAZA |
| Value | Count | Frequency (%) |
| plaza | 403 | 6.6% |
| square | 345 | 5.7% |
| the | 306 | 5.0% |
| centre | 293 | 4.8% |
| shopping | 211 | 3.5% |
| tower | 141 | 2.3% |
| paya | 106 | 1.7% |
| lebar | 106 | 1.7% |
| central | 102 | 1.7% |
| peninsula | 83 | 1.4% |
| Other values (365) | 3992 |
Most occurring characters
| Value | Count | Frequency (%) |
| E | 4043 | 10.6% |
| 3458 | 9.1% | |
| A | 3417 | 9.0% |
| N | 2752 | 7.2% |
| T | 2420 | 6.3% |
| O | 2301 | 6.0% |
| R | 2232 | 5.8% |
| L | 2097 | 5.5% |
| I | 2028 | 5.3% |
| S | 2019 | 5.3% |
| Other values (29) | 11402 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 34244 | |
| Space Separator | 3458 | 9.1% |
| Decimal Number | 281 | 0.7% |
| Other Punctuation | 181 | 0.5% |
| Dash Punctuation | 5 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 4043 | |
| A | 3417 | 10.0% |
| N | 2752 | 8.0% |
| T | 2420 | 7.1% |
| O | 2301 | 6.7% |
| R | 2232 | 6.5% |
| L | 2097 | 6.1% |
| I | 2028 | 5.9% |
| S | 2019 | 5.9% |
| P | 1678 | 4.9% |
| Other values (16) | 9257 |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 106 | |
| 2 | 62 | |
| 0 | 45 | |
| 5 | 24 | 8.5% |
| 8 | 17 | 6.0% |
| 3 | 13 | 4.6% |
| 9 | 8 | 2.8% |
| 7 | 6 | 2.1% |
Other Punctuation
| Value | Count | Frequency (%) |
| @ | 119 | |
| ' | 53 | |
| / | 9 | 5.0% |
Space Separator
| Value | Count | Frequency (%) |
| 3458 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 5 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 34244 | |
| Common | 3925 | 10.3% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| E | 4043 | |
| A | 3417 | 10.0% |
| N | 2752 | 8.0% |
| T | 2420 | 7.1% |
| O | 2301 | 6.7% |
| R | 2232 | 6.5% |
| L | 2097 | 6.1% |
| I | 2028 | 5.9% |
| S | 2019 | 5.9% |
| P | 1678 | 4.9% |
| Other values (16) | 9257 |
Common
| Value | Count | Frequency (%) |
| 3458 | ||
| @ | 119 | 3.0% |
| 1 | 106 | 2.7% |
| 2 | 62 | 1.6% |
| ' | 53 | 1.4% |
| 0 | 45 | 1.1% |
| 5 | 24 | 0.6% |
| 8 | 17 | 0.4% |
| 3 | 13 | 0.3% |
| / | 9 | 0.2% |
| Other values (3) | 19 | 0.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 38169 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| E | 4043 | 10.6% |
| 3458 | 9.1% | |
| A | 3417 | 9.0% |
| N | 2752 | 7.2% |
| T | 2420 | 6.3% |
| O | 2301 | 6.0% |
| R | 2232 | 5.8% |
| L | 2097 | 5.5% |
| I | 2028 | 5.3% |
| S | 2019 | 5.3% |
| Other values (29) | 11402 |
Street Name
Text
| Distinct | 307 |
|---|---|
| Distinct (%) | 8.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 54.8 KiB |
Length
| Max length | 30 |
|---|---|
| Median length | 24 |
| Mean length | 13.896267 |
| Min length | 9 |
Unique
| Unique | 97 ? |
|---|---|
| Unique (%) | 2.8% |
Sample
| 1st row | BENCOOLEN STREET |
|---|---|
| 2nd row | PAYA LEBAR ROAD |
| 3rd row | WOODLANDS SQUARE |
| 4th row | BENCOOLEN STREET |
| 5th row | ANSON ROAD |
| Value | Count | Frequency (%) |
| road | 2177 | |
| street | 560 | 6.7% |
| jalan | 211 | 2.5% |
| bridge | 189 | 2.2% |
| upper | 187 | 2.2% |
| north | 140 | 1.7% |
| serangoon | 127 | 1.5% |
| geylang | 124 | 1.5% |
| cecil | 113 | 1.3% |
| orchard | 113 | 1.3% |
| Other values (346) | 4470 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 5777 | |
| R | 5029 | |
| 4902 | ||
| O | 4656 | |
| E | 4568 | |
| D | 3196 | 6.6% |
| N | 2876 | 5.9% |
| T | 2602 | 5.3% |
| S | 2319 | 4.8% |
| L | 1682 | 3.4% |
| Other values (31) | 11155 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 43771 | |
| Space Separator | 4902 | 10.1% |
| Decimal Number | 74 | 0.2% |
| Other Punctuation | 10 | < 0.1% |
| Dash Punctuation | 5 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 5777 | |
| R | 5029 | |
| O | 4656 | |
| E | 4568 | |
| D | 3196 | 7.3% |
| N | 2876 | 6.6% |
| T | 2602 | 5.9% |
| S | 2319 | 5.3% |
| L | 1682 | 3.8% |
| I | 1577 | 3.6% |
| Other values (16) | 9489 |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 23 | |
| 9 | 15 | |
| 3 | 10 | |
| 2 | 8 | 10.8% |
| 7 | 7 | 9.5% |
| 5 | 5 | 6.8% |
| 6 | 3 | 4.1% |
| 4 | 2 | 2.7% |
| 8 | 1 | 1.4% |
Other Punctuation
| Value | Count | Frequency (%) |
| ' | 4 | |
| . | 3 | |
| / | 2 | |
| \ | 1 | 10.0% |
Space Separator
| Value | Count | Frequency (%) |
| 4902 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 5 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 43771 | |
| Common | 4991 | 10.2% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 5777 | |
| R | 5029 | |
| O | 4656 | |
| E | 4568 | |
| D | 3196 | 7.3% |
| N | 2876 | 6.6% |
| T | 2602 | 5.9% |
| S | 2319 | 5.3% |
| L | 1682 | 3.8% |
| I | 1577 | 3.6% |
| Other values (16) | 9489 |
Common
| Value | Count | Frequency (%) |
| 4902 | ||
| 1 | 23 | 0.5% |
| 9 | 15 | 0.3% |
| 3 | 10 | 0.2% |
| 2 | 8 | 0.2% |
| 7 | 7 | 0.1% |
| 5 | 5 | 0.1% |
| - | 5 | 0.1% |
| ' | 4 | 0.1% |
| . | 3 | 0.1% |
| Other values (5) | 9 | 0.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 48762 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| A | 5777 | |
| R | 5029 | |
| 4902 | ||
| O | 4656 | |
| E | 4568 | |
| D | 3196 | 6.6% |
| N | 2876 | 5.9% |
| T | 2602 | 5.3% |
| S | 2319 | 4.8% |
| L | 1682 | 3.4% |
| Other values (31) | 11155 |
Property Type
Categorical
High correlation
| Distinct | 3 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 54.8 KiB |
| Office | |
|---|---|
| Retail | |
| Shop House |
Length
| Max length | 10 |
|---|---|
| Median length | 6 |
| Mean length | 6.9130806 |
| Min length | 6 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Office |
|---|---|
| 2nd row | Office |
| 3rd row | Office |
| 4th row | Office |
| 5th row | Office |
Common Values
| Value | Count | Frequency (%) |
| Office | 1514 | |
| Retail | 1194 | |
| Shop House | 801 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| office | 1514 | |
| retail | 1194 | |
| shop | 801 | |
| house | 801 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 3509 | |
| f | 3028 | |
| i | 2708 | |
| o | 1602 | 6.6% |
| O | 1514 | 6.2% |
| c | 1514 | 6.2% |
| a | 1194 | 4.9% |
| l | 1194 | 4.9% |
| t | 1194 | 4.9% |
| R | 1194 | 4.9% |
| Other values (7) | 5607 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 19147 | |
| Uppercase Letter | 4310 | 17.8% |
| Space Separator | 801 | 3.3% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 3509 | |
| f | 3028 | |
| i | 2708 | |
| o | 1602 | |
| c | 1514 | |
| a | 1194 | 6.2% |
| l | 1194 | 6.2% |
| t | 1194 | 6.2% |
| h | 801 | 4.2% |
| p | 801 | 4.2% |
| Other values (2) | 1602 |
Uppercase Letter
| Value | Count | Frequency (%) |
| O | 1514 | |
| R | 1194 | |
| S | 801 | |
| H | 801 |
Space Separator
| Value | Count | Frequency (%) |
| 801 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 23457 | |
| Common | 801 | 3.3% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 3509 | |
| f | 3028 | |
| i | 2708 | |
| o | 1602 | 6.8% |
| O | 1514 | 6.5% |
| c | 1514 | 6.5% |
| a | 1194 | 5.1% |
| l | 1194 | 5.1% |
| t | 1194 | 5.1% |
| R | 1194 | 5.1% |
| Other values (6) | 4806 |
Common
| Value | Count | Frequency (%) |
| 801 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 24258 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 3509 | |
| f | 3028 | |
| i | 2708 | |
| o | 1602 | 6.6% |
| O | 1514 | 6.2% |
| c | 1514 | 6.2% |
| a | 1194 | 4.9% |
| l | 1194 | 4.9% |
| t | 1194 | 4.9% |
| R | 1194 | 4.9% |
| Other values (7) | 5607 |
Transacted Price ($)
Real number (ℝ)
High correlation
| Distinct | 1670 |
|---|---|
| Distinct (%) | 47.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7135491.9 |
| Minimum | 120000 |
|---|---|
| Maximum | 1.2814881 × 109 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 54.8 KiB |
Quantile statistics
| Minimum | 120000 |
|---|---|
| 5-th percentile | 428000 |
| Q1 | 950000 |
| median | 1860000 |
| Q3 | 4380000 |
| 95-th percentile | 16174680 |
| Maximum | 1.2814881 × 109 |
| Range | 1.2813681 × 109 |
| Interquartile range (IQR) | 3430000 |
Descriptive statistics
| Standard deviation | 44519649 |
|---|---|
| Coefficient of variation (CV) | 6.2391844 |
| Kurtosis | 470.72848 |
| Mean | 7135491.9 |
| Median Absolute Deviation (MAD) | 1162000 |
| Skewness | 19.815452 |
| Sum | 2.5038441 × 1010 |
| Variance | 1.9819992 × 1015 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 3500000 | 25 | 0.7% |
| 1200000 | 25 | 0.7% |
| 1300000 | 23 | 0.7% |
| 1500000 | 22 | 0.6% |
| 2000000 | 22 | 0.6% |
| 900000 | 22 | 0.6% |
| 1800000 | 21 | 0.6% |
| 950000 | 21 | 0.6% |
| 700000 | 21 | 0.6% |
| 1100000 | 20 | 0.6% |
| Other values (1660) | 3287 |
| Value | Count | Frequency (%) |
| 120000 | 1 | < 0.1% |
| 125000 | 1 | < 0.1% |
| 180000 | 2 | |
| 185000 | 1 | < 0.1% |
| 190000 | 1 | < 0.1% |
| 200000 | 3 | |
| 202888 | 1 | < 0.1% |
| 214888 | 1 | < 0.1% |
| 220000 | 1 | < 0.1% |
| 222888 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 1281488125 | 1 | |
| 1267511820 | 1 | |
| 810800000 | 1 | |
| 775000000 | 1 | |
| 700000000 | 1 | |
| 655000000 | 1 | |
| 538000000 | 1 | |
| 439000000 | 1 | |
| 340000000 | 1 | |
| 338000000 | 1 |
Sale Date
Date
| Distinct | 61 |
|---|---|
| Distinct (%) | 1.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 54.8 KiB |
| Minimum | 2019-10-01 00:00:00 |
|---|---|
| Maximum | 2024-10-01 00:00:00 |
Histogram with fixed size bins (bins=50)
Type of Area
Categorical
High correlation
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 54.8 KiB |
| Strata | |
|---|---|
| Land |
Length
| Max length | 6 |
|---|---|
| Median length | 6 |
| Mean length | 5.5474494 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Strata |
|---|---|
| 2nd row | Strata |
| 3rd row | Strata |
| 4th row | Strata |
| 5th row | Strata |
Common Values
| Value | Count | Frequency (%) |
| Strata | 2715 | |
| Land | 794 | 22.6% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| strata | 2715 | |
| land | 794 | 22.6% |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 6224 | |
| t | 5430 | |
| S | 2715 | |
| r | 2715 | |
| L | 794 | 4.1% |
| n | 794 | 4.1% |
| d | 794 | 4.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 15957 | |
| Uppercase Letter | 3509 | 18.0% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 6224 | |
| t | 5430 | |
| r | 2715 | |
| n | 794 | 5.0% |
| d | 794 | 5.0% |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 2715 | |
| L | 794 | 22.6% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 19466 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 6224 | |
| t | 5430 | |
| S | 2715 | |
| r | 2715 | |
| L | 794 | 4.1% |
| n | 794 | 4.1% |
| d | 794 | 4.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 19466 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 6224 | |
| t | 5430 | |
| S | 2715 | |
| r | 2715 | |
| L | 794 | 4.1% |
| n | 794 | 4.1% |
| d | 794 | 4.1% |
Area (SQM)
Real number (ℝ)
High correlation Skewed
| Distinct | 904 |
|---|---|
| Distinct (%) | 25.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 207.72742 |
| Minimum | 5 |
|---|---|
| Maximum | 61511 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 54.8 KiB |
Quantile statistics
| Minimum | 5 |
|---|---|
| 5-th percentile | 17 |
| Q1 | 38 |
| median | 70 |
| Q3 | 128.6 |
| 95-th percentile | 400.72 |
| Maximum | 61511 |
| Range | 61506 |
| Interquartile range (IQR) | 90.6 |
Descriptive statistics
| Standard deviation | 1607.4853 |
|---|---|
| Coefficient of variation (CV) | 7.7384358 |
| Kurtosis | 1051.2656 |
| Mean | 207.72742 |
| Median Absolute Deviation (MAD) | 39 |
| Skewness | 29.904205 |
| Sum | 728915.5 |
| Variance | 2584008.9 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 32 | 60 | 1.7% |
| 37 | 57 | 1.6% |
| 52 | 55 | 1.6% |
| 59 | 43 | 1.2% |
| 60 | 42 | 1.2% |
| 29 | 40 | 1.1% |
| 47 | 40 | 1.1% |
| 19 | 40 | 1.1% |
| 48 | 40 | 1.1% |
| 44 | 39 | 1.1% |
| Other values (894) | 3053 |
| Value | Count | Frequency (%) |
| 5 | 2 | 0.1% |
| 6 | 4 | 0.1% |
| 7 | 3 | 0.1% |
| 8 | 7 | 0.2% |
| 9 | 10 | |
| 10 | 13 | |
| 11 | 12 | |
| 12 | 14 | |
| 13 | 20 | |
| 14 | 17 |
| Value | Count | Frequency (%) |
| 61511 | 1 | |
| 56673 | 1 | |
| 19976 | 1 | |
| 16673 | 1 | |
| 14006.1 | 1 | |
| 12898.2 | 1 | |
| 12096.9 | 1 | |
| 10369 | 1 | |
| 10257 | 1 | |
| 9807 | 1 |
Unit Price ($ PSM)
Real number (ℝ)
High correlation
| Distinct | 2929 |
|---|---|
| Distinct (%) | 83.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 34758.379 |
| Minimum | 1801 |
|---|---|
| Maximum | 1219955 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 54.8 KiB |
Quantile statistics
| Minimum | 1801 |
|---|---|
| 5-th percentile | 13522.2 |
| Q1 | 20690 |
| median | 27778 |
| Q3 | 39583 |
| 95-th percentile | 79098.8 |
| Maximum | 1219955 |
| Range | 1218154 |
| Interquartile range (IQR) | 18893 |
Descriptive statistics
| Standard deviation | 31634.23 |
|---|---|
| Coefficient of variation (CV) | 0.91011809 |
| Kurtosis | 567.29496 |
| Mean | 34758.379 |
| Median Absolute Deviation (MAD) | 8402 |
| Skewness | 16.56695 |
| Sum | 1.2196715 × 108 |
| Variance | 1.0007245 × 109 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 20000 | 22 | 0.6% |
| 25000 | 20 | 0.6% |
| 50000 | 10 | 0.3% |
| 30000 | 9 | 0.3% |
| 15000 | 9 | 0.3% |
| 26667 | 9 | 0.3% |
| 16667 | 8 | 0.2% |
| 24000 | 8 | 0.2% |
| 37500 | 7 | 0.2% |
| 27500 | 7 | 0.2% |
| Other values (2919) | 3400 |
| Value | Count | Frequency (%) |
| 1801 | 1 | |
| 3431 | 1 | |
| 4242 | 1 | |
| 5495 | 1 | |
| 5542 | 1 | |
| 5764 | 1 | |
| 5765 | 1 | |
| 5927 | 1 | |
| 6054 | 1 | |
| 6064 | 1 |
| Value | Count | Frequency (%) |
| 1219955 | 1 | |
| 296406 | 1 | |
| 278735 | 1 | |
| 238273 | 1 | |
| 228972 | 1 | |
| 226415 | 1 | |
| 221277 | 1 | |
| 217941 | 1 | |
| 209953 | 1 | |
| 182215 | 1 |
Postal District
Real number (ℝ)
High correlation
| Distinct | 25 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 9.1567398 |
| Minimum | 1 |
|---|---|
| Maximum | 27 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 54.8 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 3 |
| median | 8 |
| Q3 | 14 |
| 95-th percentile | 21 |
| Maximum | 27 |
| Range | 26 |
| Interquartile range (IQR) | 11 |
Descriptive statistics
| Standard deviation | 6.57107 |
|---|---|
| Coefficient of variation (CV) | 0.71762113 |
| Kurtosis | -0.28445912 |
| Mean | 9.1567398 |
| Median Absolute Deviation (MAD) | 6 |
| Skewness | 0.62435033 |
| Sum | 32131 |
| Variance | 43.17896 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=25)
| Value | Count | Frequency (%) |
| 1 | 619 | |
| 7 | 433 | |
| 8 | 422 | |
| 14 | 377 | |
| 9 | 240 | 6.8% |
| 15 | 232 | 6.6% |
| 2 | 213 | 6.1% |
| 6 | 161 | 4.6% |
| 12 | 111 | 3.2% |
| 21 | 109 | 3.1% |
| Other values (15) | 592 |
| Value | Count | Frequency (%) |
| 1 | 619 | |
| 2 | 213 | 6.1% |
| 3 | 99 | 2.8% |
| 4 | 5 | 0.1% |
| 5 | 36 | 1.0% |
| 6 | 161 | 4.6% |
| 7 | 433 | |
| 8 | 422 | |
| 9 | 240 | 6.8% |
| 10 | 47 | 1.3% |
| Value | Count | Frequency (%) |
| 27 | 24 | 0.7% |
| 26 | 7 | 0.2% |
| 25 | 86 | |
| 23 | 11 | 0.3% |
| 22 | 45 | |
| 21 | 109 | |
| 20 | 34 | 1.0% |
| 19 | 105 | |
| 18 | 9 | 0.3% |
| 16 | 35 | 1.0% |
District Name
Categorical
High correlation
| Distinct | 25 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 54.8 KiB |
| Raffles Place, Cecil, Marina, People's Park | |
|---|---|
| Middle Road, Golden Mile | |
| Little India | |
| Geylang, Eunos | |
| Orchard, Cairnhill, River Valley | |
| Other values (20) |
Length
| Max length | 52 |
|---|---|
| Median length | 44 |
| Mean length | 28.170989 |
| Min length | 7 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Middle Road, Golden Mile |
|---|---|
| 2nd row | Geylang, Eunos |
| 3rd row | Kranji, Woodgrove |
| 4th row | Middle Road, Golden Mile |
| 5th row | Anson, Tanjong Pagar |
Common Values
| Value | Count | Frequency (%) |
| Raffles Place, Cecil, Marina, People's Park | 619 | |
| Middle Road, Golden Mile | 433 | |
| Little India | 422 | |
| Geylang, Eunos | 377 | |
| Orchard, Cairnhill, River Valley | 240 | 6.8% |
| Katong, Joo Chiat, Amber Road | 232 | 6.6% |
| Anson, Tanjong Pagar | 213 | 6.1% |
| High Street, Beach Road (part) | 161 | 4.6% |
| Balestier, Toa Payoh, Serangoon | 111 | 3.2% |
| Upper Bukit Timah, Clementi Park, Ulu Pandan | 109 | 3.1% |
| Other values (15) | 592 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| road | 873 | 6.2% |
| park | 728 | 5.2% |
| raffles | 619 | 4.4% |
| people's | 619 | 4.4% |
| place | 619 | 4.4% |
| marina | 619 | 4.4% |
| cecil | 619 | 4.4% |
| middle | 433 | 3.1% |
| golden | 433 | 3.1% |
| mile | 433 | 3.1% |
| Other values (77) | 8052 |
Most occurring characters
| Value | Count | Frequency (%) |
| 14047 | ||
| a | 8993 | 9.1% |
| e | 8095 | 8.2% |
| l | 6232 | 6.3% |
| n | 5728 | 5.8% |
| o | 5338 | 5.4% |
| , | 5324 | 5.4% |
| i | 5102 | 5.2% |
| r | 4275 | 4.3% |
| d | 3382 | 3.4% |
| Other values (42) | 32336 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 64654 | |
| Space Separator | 14047 | 14.2% |
| Uppercase Letter | 13886 | 14.0% |
| Other Punctuation | 5943 | 6.0% |
| Close Punctuation | 161 | 0.2% |
| Open Punctuation | 161 | 0.2% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| P | 2596 | |
| R | 1741 | |
| M | 1543 | |
| C | 1293 | |
| G | 951 | 6.8% |
| T | 708 | 5.1% |
| B | 636 | 4.6% |
| A | 526 | 3.8% |
| E | 472 | 3.4% |
| L | 458 | 3.3% |
| Other values (14) | 2962 |
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 8993 | |
| e | 8095 | |
| l | 6232 | |
| n | 5728 | |
| o | 5338 | |
| i | 5102 | |
| r | 4275 | 6.6% |
| d | 3382 | 5.2% |
| t | 2523 | 3.9% |
| s | 2345 | 3.6% |
| Other values (13) | 12641 |
Other Punctuation
| Value | Count | Frequency (%) |
| , | 5324 | |
| ' | 619 | 10.4% |
Space Separator
| Value | Count | Frequency (%) |
| 14047 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 161 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 161 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 78540 | |
| Common | 20312 | 20.5% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 8993 | 11.5% |
| e | 8095 | 10.3% |
| l | 6232 | 7.9% |
| n | 5728 | 7.3% |
| o | 5338 | 6.8% |
| i | 5102 | 6.5% |
| r | 4275 | 5.4% |
| d | 3382 | 4.3% |
| P | 2596 | 3.3% |
| t | 2523 | 3.2% |
| Other values (37) | 26276 |
Common
| Value | Count | Frequency (%) |
| 14047 | ||
| , | 5324 | 26.2% |
| ' | 619 | 3.0% |
| ) | 161 | 0.8% |
| ( | 161 | 0.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 98852 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 14047 | ||
| a | 8993 | 9.1% |
| e | 8095 | 8.2% |
| l | 6232 | 6.3% |
| n | 5728 | 5.8% |
| o | 5338 | 5.4% |
| , | 5324 | 5.4% |
| i | 5102 | 5.2% |
| r | 4275 | 4.3% |
| d | 3382 | 3.4% |
| Other values (42) | 32336 |
Tenure Type
Categorical
High correlation
| Distinct | 3 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 54.8 KiB |
| Leasehold | |
|---|---|
| Freehold | |
| Unknown | 1 |
Length
| Max length | 9 |
|---|---|
| Median length | 9 |
| Mean length | 8.5856369 |
| Min length | 7 |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Leasehold |
|---|---|
| 2nd row | Leasehold |
| 3rd row | Leasehold |
| 4th row | Leasehold |
| 5th row | Leasehold |
Common Values
| Value | Count | Frequency (%) |
| Leasehold | 2056 | |
| Freehold | 1452 | |
| Unknown | 1 | < 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| leasehold | 2056 | |
| freehold | 1452 | |
| unknown | 1 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 7016 | |
| o | 3509 | |
| h | 3508 | |
| l | 3508 | |
| d | 3508 | |
| L | 2056 | 6.8% |
| a | 2056 | 6.8% |
| s | 2056 | 6.8% |
| F | 1452 | 4.8% |
| r | 1452 | 4.8% |
| Other values (4) | 6 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 26618 | |
| Uppercase Letter | 3509 | 11.6% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 7016 | |
| o | 3509 | |
| h | 3508 | |
| l | 3508 | |
| d | 3508 | |
| a | 2056 | 7.7% |
| s | 2056 | 7.7% |
| r | 1452 | 5.5% |
| n | 3 | < 0.1% |
| k | 1 | < 0.1% |
Uppercase Letter
| Value | Count | Frequency (%) |
| L | 2056 | |
| F | 1452 | |
| U | 1 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 30127 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 7016 | |
| o | 3509 | |
| h | 3508 | |
| l | 3508 | |
| d | 3508 | |
| L | 2056 | 6.8% |
| a | 2056 | 6.8% |
| s | 2056 | 6.8% |
| F | 1452 | 4.8% |
| r | 1452 | 4.8% |
| Other values (4) | 6 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 30127 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 7016 | |
| o | 3509 | |
| h | 3508 | |
| l | 3508 | |
| d | 3508 | |
| L | 2056 | 6.8% |
| a | 2056 | 6.8% |
| s | 2056 | 6.8% |
| F | 1452 | 4.8% |
| r | 1452 | 4.8% |
| Other values (4) | 6 | < 0.1% |
Lease Years
Real number (ℝ)
High correlation Missing
| Distinct | 14 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 1453 |
| Missing (%) | 41.4% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 325.48346 |
| Minimum | 30 |
|---|---|
| Maximum | 9999 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 54.8 KiB |
Quantile statistics
| Minimum | 30 |
|---|---|
| 5-th percentile | 99 |
| Q1 | 99 |
| median | 99 |
| Q3 | 99 |
| 95-th percentile | 999 |
| Maximum | 9999 |
| Range | 9969 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 793.72825 |
|---|---|
| Coefficient of variation (CV) | 2.4386131 |
| Kurtosis | 115.54157 |
| Mean | 325.48346 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 9.7985664 |
| Sum | 669194 |
| Variance | 630004.53 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=14)
| Value | Count | Frequency (%) |
| 99 | 1599 | |
| 999 | 389 | 11.1% |
| 63 | 24 | 0.7% |
| 60 | 14 | 0.4% |
| 9999 | 11 | 0.3% |
| 956 | 5 | 0.1% |
| 199 | 3 | 0.1% |
| 103 | 2 | 0.1% |
| 998 | 2 | 0.1% |
| 98 | 2 | 0.1% |
| Other values (4) | 5 | 0.1% |
| (Missing) | 1453 |
| Value | Count | Frequency (%) |
| 30 | 1 | < 0.1% |
| 60 | 14 | 0.4% |
| 63 | 24 | 0.7% |
| 85 | 1 | < 0.1% |
| 95 | 1 | < 0.1% |
| 98 | 2 | 0.1% |
| 99 | 1599 | |
| 103 | 2 | 0.1% |
| 199 | 3 | 0.1% |
| 956 | 5 | 0.1% |
| Value | Count | Frequency (%) |
| 9999 | 11 | 0.3% |
| 999 | 389 | 11.1% |
| 998 | 2 | 0.1% |
| 978 | 2 | 0.1% |
| 956 | 5 | 0.1% |
| 199 | 3 | 0.1% |
| 103 | 2 | 0.1% |
| 99 | 1599 | |
| 98 | 2 | 0.1% |
| 95 | 1 | < 0.1% |
Floor Min
Real number (ℝ)
High correlation Missing
| Distinct | 10 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 891 |
| Missing (%) | 25.4% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.8342246 |
| Minimum | -1 |
|---|---|
| Maximum | 41 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 121 |
| Negative (%) | 3.4% |
| Memory size | 54.8 KiB |
Quantile statistics
| Minimum | -1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 6 |
| 95-th percentile | 21 |
| Maximum | 41 |
| Range | 42 |
| Interquartile range (IQR) | 5 |
Descriptive statistics
| Standard deviation | 6.6432671 |
|---|---|
| Coefficient of variation (CV) | 1.3742156 |
| Kurtosis | 4.8488122 |
| Mean | 4.8342246 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 2.0868377 |
| Sum | 12656 |
| Variance | 44.132997 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) |
| 1 | 1502 | |
| 6 | 469 | 13.4% |
| 11 | 249 | 7.1% |
| 16 | 131 | 3.7% |
| -1 | 121 | 3.4% |
| 21 | 86 | 2.5% |
| 26 | 29 | 0.8% |
| 36 | 15 | 0.4% |
| 31 | 13 | 0.4% |
| 41 | 3 | 0.1% |
| (Missing) | 891 |
| Value | Count | Frequency (%) |
| -1 | 121 | 3.4% |
| 1 | 1502 | |
| 6 | 469 | 13.4% |
| 11 | 249 | 7.1% |
| 16 | 131 | 3.7% |
| 21 | 86 | 2.5% |
| 26 | 29 | 0.8% |
| 31 | 13 | 0.4% |
| 36 | 15 | 0.4% |
| 41 | 3 | 0.1% |
| Value | Count | Frequency (%) |
| 41 | 3 | 0.1% |
| 36 | 15 | 0.4% |
| 31 | 13 | 0.4% |
| 26 | 29 | 0.8% |
| 21 | 86 | 2.5% |
| 16 | 131 | 3.7% |
| 11 | 249 | 7.1% |
| 6 | 469 | 13.4% |
| 1 | 1502 | |
| -1 | 121 | 3.4% |
Floor Max
Real number (ℝ)
High correlation Missing
| Distinct | 10 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 891 |
| Missing (%) | 25.4% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8.4644767 |
| Minimum | -5 |
|---|---|
| Maximum | 45 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 121 |
| Negative (%) | 3.4% |
| Memory size | 54.8 KiB |
Quantile statistics
| Minimum | -5 |
|---|---|
| 5-th percentile | 5 |
| Q1 | 5 |
| median | 5 |
| Q3 | 10 |
| 95-th percentile | 25 |
| Maximum | 45 |
| Range | 50 |
| Interquartile range (IQR) | 5 |
Descriptive statistics
| Standard deviation | 7.1604035 |
|---|---|
| Coefficient of variation (CV) | 0.84593575 |
| Kurtosis | 3.7367819 |
| Mean | 8.4644767 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.5130535 |
| Sum | 22160 |
| Variance | 51.271378 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) |
| 5 | 1502 | |
| 10 | 469 | 13.4% |
| 15 | 249 | 7.1% |
| 20 | 131 | 3.7% |
| -5 | 121 | 3.4% |
| 25 | 86 | 2.5% |
| 30 | 29 | 0.8% |
| 40 | 15 | 0.4% |
| 35 | 13 | 0.4% |
| 45 | 3 | 0.1% |
| (Missing) | 891 |
| Value | Count | Frequency (%) |
| -5 | 121 | 3.4% |
| 5 | 1502 | |
| 10 | 469 | 13.4% |
| 15 | 249 | 7.1% |
| 20 | 131 | 3.7% |
| 25 | 86 | 2.5% |
| 30 | 29 | 0.8% |
| 35 | 13 | 0.4% |
| 40 | 15 | 0.4% |
| 45 | 3 | 0.1% |
| Value | Count | Frequency (%) |
| 45 | 3 | 0.1% |
| 40 | 15 | 0.4% |
| 35 | 13 | 0.4% |
| 30 | 29 | 0.8% |
| 25 | 86 | 2.5% |
| 20 | 131 | 3.7% |
| 15 | 249 | 7.1% |
| 10 | 469 | 13.4% |
| 5 | 1502 | |
| -5 | 121 | 3.4% |
Floor Category
Categorical
High correlation
| Distinct | 7 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 54.8 KiB |
| 01-05 | |
|---|---|
| Unknown | |
| 06-10 | |
| 11-15 | |
| 21+ | 146 |
| Other values (2) |
Length
| Max length | 8 |
|---|---|
| Median length | 5 |
| Mean length | 5.5280707 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 01-05 |
|---|---|
| 2nd row | 01-05 |
| 3rd row | 06-10 |
| 4th row | 06-10 |
| 5th row | 16-20 |
Common Values
| Value | Count | Frequency (%) |
| 01-05 | 1502 | |
| Unknown | 891 | |
| 06-10 | 469 | 13.4% |
| 11-15 | 249 | 7.1% |
| 21+ | 146 | 4.2% |
| 16-20 | 131 | 3.7% |
| Basement | 121 | 3.4% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 01-05 | 1502 | |
| unknown | 891 | |
| 06-10 | 469 | 13.4% |
| 11-15 | 249 | 7.1% |
| 21 | 146 | 4.2% |
| 16-20 | 131 | 3.7% |
| basement | 121 | 3.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 4073 | |
| 1 | 2995 | |
| n | 2794 | |
| - | 2351 | |
| 5 | 1751 | |
| U | 891 | 4.6% |
| k | 891 | 4.6% |
| o | 891 | 4.6% |
| w | 891 | 4.6% |
| 6 | 600 | 3.1% |
| Other values (8) | 1270 | 6.5% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 9696 | |
| Lowercase Letter | 6193 | |
| Dash Punctuation | 2351 | 12.1% |
| Uppercase Letter | 1012 | 5.2% |
| Math Symbol | 146 | 0.8% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| n | 2794 | |
| k | 891 | 14.4% |
| o | 891 | 14.4% |
| w | 891 | 14.4% |
| e | 242 | 3.9% |
| a | 121 | 2.0% |
| s | 121 | 2.0% |
| m | 121 | 2.0% |
| t | 121 | 2.0% |
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 4073 | |
| 1 | 2995 | |
| 5 | 1751 | |
| 6 | 600 | 6.2% |
| 2 | 277 | 2.9% |
Uppercase Letter
| Value | Count | Frequency (%) |
| U | 891 | |
| B | 121 | 12.0% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 2351 |
Math Symbol
| Value | Count | Frequency (%) |
| + | 146 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 12193 | |
| Latin | 7205 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| n | 2794 | |
| U | 891 | 12.4% |
| k | 891 | 12.4% |
| o | 891 | 12.4% |
| w | 891 | 12.4% |
| e | 242 | 3.4% |
| B | 121 | 1.7% |
| a | 121 | 1.7% |
| s | 121 | 1.7% |
| m | 121 | 1.7% |
Common
| Value | Count | Frequency (%) |
| 0 | 4073 | |
| 1 | 2995 | |
| - | 2351 | |
| 5 | 1751 | |
| 6 | 600 | 4.9% |
| 2 | 277 | 2.3% |
| + | 146 | 1.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 19398 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 4073 | |
| 1 | 2995 | |
| n | 2794 | |
| - | 2351 | |
| 5 | 1751 | |
| U | 891 | 4.6% |
| k | 891 | 4.6% |
| o | 891 | 4.6% |
| w | 891 | 4.6% |
| 6 | 600 | 3.1% |
| Other values (8) | 1270 | 6.5% |
Transaction Year
Real number (ℝ)
| Distinct | 6 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2021.815 |
| Minimum | 2019 |
|---|---|
| Maximum | 2024 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 41.1 KiB |
Quantile statistics
| Minimum | 2019 |
|---|---|
| 5-th percentile | 2020 |
| Q1 | 2021 |
| median | 2022 |
| Q3 | 2023 |
| 95-th percentile | 2024 |
| Maximum | 2024 |
| Range | 5 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 1.3978895 |
|---|---|
| Coefficient of variation (CV) | 0.00069140326 |
| Kurtosis | -0.88557388 |
| Mean | 2021.815 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | -0.06361689 |
| Sum | 7094549 |
| Variance | 1.9540951 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=6)
| Value | Count | Frequency (%) |
| 2021 | 885 | |
| 2022 | 763 | |
| 2023 | 713 | |
| 2020 | 497 | |
| 2024 | 494 | |
| 2019 | 157 | 4.5% |
| Value | Count | Frequency (%) |
| 2019 | 157 | 4.5% |
| 2020 | 497 | |
| 2021 | 885 | |
| 2022 | 763 | |
| 2023 | 713 | |
| 2024 | 494 |
| Value | Count | Frequency (%) |
| 2024 | 494 | |
| 2023 | 713 | |
| 2022 | 763 | |
| 2021 | 885 | |
| 2020 | 497 | |
| 2019 | 157 | 4.5% |
Transaction Month
Real number (ℝ)
| Distinct | 12 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.6164149 |
| Minimum | 1 |
|---|---|
| Maximum | 12 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 41.1 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 4 |
| median | 7 |
| Q3 | 10 |
| 95-th percentile | 12 |
| Maximum | 12 |
| Range | 11 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 3.4116013 |
|---|---|
| Coefficient of variation (CV) | 0.51562687 |
| Kurtosis | -1.2072962 |
| Mean | 6.6164149 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | -0.017217724 |
| Sum | 23217 |
| Variance | 11.639024 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=12)
| Value | Count | Frequency (%) |
| 10 | 354 | |
| 6 | 327 | |
| 3 | 323 | |
| 4 | 316 | |
| 12 | 298 | |
| 7 | 295 | |
| 11 | 292 | |
| 5 | 273 | |
| 8 | 271 | |
| 9 | 262 | |
| Other values (2) | 498 |
| Value | Count | Frequency (%) |
| 1 | 258 | |
| 2 | 240 | |
| 3 | 323 | |
| 4 | 316 | |
| 5 | 273 | |
| 6 | 327 | |
| 7 | 295 | |
| 8 | 271 | |
| 9 | 262 | |
| 10 | 354 |
| Value | Count | Frequency (%) |
| 12 | 298 | |
| 11 | 292 | |
| 10 | 354 | |
| 9 | 262 | |
| 8 | 271 | |
| 7 | 295 | |
| 6 | 327 | |
| 5 | 273 | |
| 4 | 316 | |
| 3 | 323 |
Interactions
Correlations
| Area (SQM) | District Name | Floor Category | Floor Max | Floor Min | Lease Years | Postal District | Property Type | Tenure Type | Transacted Price ($) | Transaction Month | Transaction Year | Type of Area | Unit Price ($ PSM) | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Area (SQM) | 1.000 | 0.128 | 0.000 | 0.520 | 0.520 | 0.036 | -0.162 | 0.020 | 0.000 | 0.877 | 0.047 | -0.060 | 0.036 | 0.076 |
| District Name | 0.128 | 1.000 | 0.298 | 0.232 | 0.232 | 0.534 | 0.998 | 0.426 | 0.436 | 0.010 | 0.040 | 0.077 | 0.438 | 0.055 |
| Floor Category | 0.000 | 0.298 | 1.000 | 0.999 | 0.999 | 0.053 | 0.235 | 0.784 | 0.239 | 0.023 | 0.035 | 0.084 | 0.926 | 0.092 |
| Floor Max | 0.520 | 0.232 | 0.999 | 1.000 | 1.000 | -0.128 | -0.364 | 0.433 | 0.273 | 0.444 | 0.058 | -0.013 | 1.000 | -0.018 |
| Floor Min | 0.520 | 0.232 | 0.999 | 1.000 | 1.000 | -0.128 | -0.364 | 0.433 | 0.273 | 0.444 | 0.058 | -0.013 | 1.000 | -0.018 |
| Lease Years | 0.036 | 0.534 | 0.053 | -0.128 | -0.128 | 1.000 | 0.001 | 0.057 | 1.000 | 0.167 | -0.000 | -0.053 | 0.000 | 0.329 |
| Postal District | -0.162 | 0.998 | 0.235 | -0.364 | -0.364 | 0.001 | 1.000 | 0.311 | 0.324 | -0.234 | -0.011 | 0.043 | 0.280 | -0.186 |
| Property Type | 0.020 | 0.426 | 0.784 | 0.433 | 0.433 | 0.057 | 0.311 | 1.000 | 0.205 | 0.000 | 0.006 | 0.092 | 0.949 | 0.081 |
| Tenure Type | 0.000 | 0.436 | 0.239 | 0.273 | 0.273 | 1.000 | 0.324 | 0.205 | 1.000 | 0.000 | 0.041 | 0.029 | 0.223 | 0.000 |
| Transacted Price ($) | 0.877 | 0.010 | 0.023 | 0.444 | 0.444 | 0.167 | -0.234 | 0.000 | 0.000 | 1.000 | 0.050 | -0.028 | 0.060 | 0.502 |
| Transaction Month | 0.047 | 0.040 | 0.035 | 0.058 | 0.058 | -0.000 | -0.011 | 0.006 | 0.041 | 0.050 | 1.000 | -0.224 | 0.000 | 0.009 |
| Transaction Year | -0.060 | 0.077 | 0.084 | -0.013 | -0.013 | -0.053 | 0.043 | 0.092 | 0.029 | -0.028 | -0.224 | 1.000 | 0.136 | 0.059 |
| Type of Area | 0.036 | 0.438 | 0.926 | 1.000 | 1.000 | 0.000 | 0.280 | 0.949 | 0.223 | 0.060 | 0.000 | 0.136 | 1.000 | 0.163 |
| Unit Price ($ PSM) | 0.076 | 0.055 | 0.092 | -0.018 | -0.018 | 0.329 | -0.186 | 0.081 | 0.000 | 0.502 | 0.009 | 0.059 | 0.163 | 1.000 |
Missing values
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.
Sample
| Project Name | Street Name | Property Type | Transacted Price ($) | Sale Date | Type of Area | Area (SQM) | Unit Price ($ PSM) | Postal District | District Name | Tenure Type | Lease Years | Floor Min | Floor Max | Floor Category | Transaction Year | Transaction Month | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | SUNSHINE PLAZA | BENCOOLEN STREET | Office | 850000 | 2024-10-01 | Strata | 45 | 18889 | 7 | Middle Road, Golden Mile | Leasehold | 99 | 1 | 5 | 01-05 | 2024 | 10 |
| 1 | PAYA LEBAR SQUARE | PAYA LEBAR ROAD | Office | 2318000 | 2024-10-01 | Strata | 99 | 23414 | 14 | Geylang, Eunos | Leasehold | 99 | 1 | 5 | 01-05 | 2024 | 10 |
| 2 | WOODS SQUARE | WOODLANDS SQUARE | Office | 1230000 | 2024-10-01 | Strata | 52 | 23654 | 25 | Kranji, Woodgrove | Leasehold | 99 | 6 | 10 | 06-10 | 2024 | 10 |
| 3 | SUNSHINE PLAZA | BENCOOLEN STREET | Office | 1120000 | 2024-10-01 | Strata | 59 | 18983 | 7 | Middle Road, Golden Mile | Leasehold | 99 | 6 | 10 | 06-10 | 2024 | 10 |
| 4 | INTERNATIONAL PLAZA | ANSON ROAD | Office | 1763580 | 2024-10-01 | Strata | 90 | 19595 | 2 | Anson, Tanjong Pagar | Leasehold | 99 | 16 | 20 | 16-20 | 2024 | 10 |
| 5 | SUNSHINE PLAZA | BENCOOLEN STREET | Office | 1150000 | 2024-10-01 | Strata | 62 | 18548 | 7 | Middle Road, Golden Mile | Leasehold | 99 | 1 | 5 | 01-05 | 2024 | 10 |
| 6 | 111 SOMERSET | SOMERSET ROAD | Office | 2200000 | 2024-10-01 | Strata | 73 | 30137 | 9 | Orchard, Cairnhill, River Valley | Leasehold | 99 | 11 | 15 | 11-15 | 2024 | 10 |
| 7 | SOUTHBANK | NORTH BRIDGE ROAD | Office | 1688888 | 2024-10-01 | Strata | 94 | 17967 | 7 | Middle Road, Golden Mile | Leasehold | 99 | 16 | 20 | 16-20 | 2024 | 10 |
| 8 | INTERNATIONAL PLAZA | ANSON ROAD | Office | 3500000 | 2024-10-01 | Strata | 219 | 15982 | 2 | Anson, Tanjong Pagar | Leasehold | 99 | 11 | 15 | 11-15 | 2024 | 10 |
| 9 | SUNSHINE PLAZA | BENCOOLEN STREET | Office | 1280000 | 2024-10-01 | Strata | 68 | 18824 | 7 | Middle Road, Golden Mile | Leasehold | 99 | 1 | 5 | 01-05 | 2024 | 10 |
| Project Name | Street Name | Property Type | Transacted Price ($) | Sale Date | Type of Area | Area (SQM) | Unit Price ($ PSM) | Postal District | District Name | Tenure Type | Lease Years | Floor Min | Floor Max | Floor Category | Transaction Year | Transaction Month | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3546 | <NA> | HONGKONG STREET | Shop House | 7100000 | 2019-11-01 | Land | 155 | 45777 | 1 | Raffles Place, Cecil, Marina, People's Park | Leasehold | 99 | <NA> | <NA> | Unknown | 2019 | 11 |
| 3547 | <NA> | JOO CHIAT ROAD | Shop House | 23200000 | 2019-11-01 | Land | 973 | 23854 | 15 | Katong, Joo Chiat, Amber Road | Freehold | NaN | <NA> | <NA> | Unknown | 2019 | 11 |
| 3548 | <NA> | JALAN BESAR | Shop House | 5300000 | 2019-11-01 | Land | 137 | 38714 | 8 | Little India | Freehold | NaN | <NA> | <NA> | Unknown | 2019 | 11 |
| 3549 | <NA> | NORRIS ROAD | Shop House | 2950000 | 2019-11-01 | Land | 91 | 32311 | 8 | Little India | Freehold | NaN | <NA> | <NA> | Unknown | 2019 | 11 |
| 3550 | <NA> | DICKSON ROAD | Shop House | 3000000 | 2019-11-01 | Land | 132 | 22796 | 8 | Little India | Leasehold | 99 | <NA> | <NA> | Unknown | 2019 | 11 |
| 3551 | <NA> | JOO CHIAT PLACE | Shop House | 8000000 | 2019-11-01 | Land | 331 | 24155 | 15 | Katong, Joo Chiat, Amber Road | Freehold | NaN | <NA> | <NA> | Unknown | 2019 | 11 |
| 3552 | <NA> | OUTRAM ROAD | Shop House | 5180000 | 2019-10-01 | Land | 142 | 36479 | 3 | Queenstown, Tiong Bahru | Freehold | NaN | <NA> | <NA> | Unknown | 2019 | 10 |
| 3553 | <NA> | PAGODA STREET | Shop House | 16250000 | 2019-10-01 | Land | 122 | 133525 | 1 | Raffles Place, Cecil, Marina, People's Park | Freehold | NaN | <NA> | <NA> | Unknown | 2019 | 10 |
| 3554 | <NA> | SMITH STREET | Shop House | 7000000 | 2019-10-01 | Land | 100 | 70000 | 1 | Raffles Place, Cecil, Marina, People's Park | Leasehold | 999 | <NA> | <NA> | Unknown | 2019 | 10 |
| 3555 | <NA> | KILLINEY ROAD | Shop House | 6050000 | 2019-10-01 | Land | 105 | 57455 | 9 | Orchard, Cairnhill, River Valley | Freehold | NaN | <NA> | <NA> | Unknown | 2019 | 10 |